package com.neusoft.elm.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.neusoft.elm.dao.AdminDao;
import com.neusoft.elm.po.Admin;
import com.neusoft.elm.util.DBUtil;
public class AdminDaoImpl implements AdminDao{
 
 private Connection con = null;
 private PreparedStatement pst = null;
 private ResultSet rs = null;
 @Override
 public Admin getAdminByNameByPass(String adminName, String password) {
 Admin admin = null;
 String sql = "select * from admin where adminName=? and password=?";
 try {
 con = DBUtil.getConnection();
 pst = con.prepareStatement(sql);
 pst.setString(1, adminName);
 pst.setString(2, password);
 rs = pst.executeQuery();
 while(rs.next()) {
 admin = new Admin();
 admin.setAdminId(rs.getInt("adminId"));
 admin.setAdminName(rs.getString("adminName"));
 admin.setPassword(rs.getString("password"));
 }
 } catch (SQLException e) {
 e.printStackTrace();
 } finally {
 DBUtil.close(rs, pst, con);
 }
 return admin;
 }
}